Skip to main content

TABLE ACCESS BY INDEX ROWID BATCHED

Short Description

Rows are located using index(es).

Detailed Description​

Rows are being retrieved from the table by ROWID after the IDs have been obtained from a supporting index. ROWIDs are used by Oracle to represent a physical location on disc and are the quickest way to access single blocks.

This BATCHED operation reads ROWIDs from the index and tries to improve the clustering and reduce the number of times any one block is accessed.

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.